﻿CREATE VIEW [dbo].[ASMS_V_StockThresholdValue]
	AS 
SELECT STV.*,
	W.Name as WarehouseName,
	M.Name as MaterialName,
	MDI.Name as MaterialUnitName
FROM ASMS_StockThresholdValue as STV
	left join ASMS_Warehouse as W on W.Id = STV.WarehouseId
	left join ASMS_Material as M on M.Id = STV.MaterialId
	left join ASMS_MasterDataItem as MDI on MDI.Code = M.Unit
